How to: Create a custom dictionary.
Solution:
Select 'Spelling' from the 'Tools' menu. Create a custom dictionary by typing a name for the dictionary in the 'Add Words To' drop-down list box.
NOTE: The following procedure assumes that there are words in the current worksheet that are not recognized by Excel. If there are no unrecognized words, Excel will not display the 'Spelling' dialog box.
1) Select the 'Tools' menu and select 'Spelling'. (The Spelling dialog box appears.)
NOTE: The first word in the current worksheet that is not found in the built-in dictionary is displayed in the dialog box.
2) Type a name for the custom dictionary in the 'Add Words To' drop-down list box.
the Add Words To drop-down list box
3) Click 'Add'. (A message appears stating the custom dictionary does not exist and asking whether to create the dictionary.)
4) Click 'Yes' to create the custom dictionary and to add the word to the dictionary.
NOTE: To add additional words to the custom dictionary, click 'Add' while the word is displayed in the 'Spelling' dialog box.